{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Planner","Hidden","Rentals","Food","Checkout","Help"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Planner","index":0,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Backpacking Trip Planner and Rental Agency"]
[]
[]
[]
[]
[]
[]
[]
[]
["Calorie Calculator:",null,null,"Trip Information:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Gear Information:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Food Information:"]
["Daily Calories Used:",3723.2088421127633]

{"sheet":"Hidden","index":1,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Weather Conditions:","sunny",3]
[null,"overcast",2]
[null,"rain","15 to 29"]
[null,"snow"]
[null,"wind"]
[]
["Night Temperature Range:","40 or above"]
[null,"30 to 39"]
[null,"15 to 29"]
[null,"1 to 14"]
[null,"below 0"]
[]
[]
["Climate:","Semiaried Steppe "]
[null,"Humid Subtropical"]
[null,"Marine Westcoast"]
[null,"Mediterranean"]
[null,"Humid Continental (Warm)"]
[null,"Humid Continental (Cool)"]
[null,"Highland (Alpine)"]
[null,"Tropical Wet/Dry Season"]
[null,"Midlatitude Desert"]
[]
["People:",1]
[null,2]
[null,3]
[null,4]
["Cards:","Credit"]
[null,"Debit"]

{"sheet":"Rentals","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Gear Rentals"]
["Item","Price/Day","Days","Quantity","Subtotal"]
["Backpack",15,3,1,{"$f":"B3*C3*D3","v":45}]
["Tent",15,3,1,{"$f":"B4*C4*D4","v":45}]
["Sleeping Bag",10,3,1,30]
["Water Filter",5,3,null,0]
["Rain Jacket",7.5,3,null,0]
["Puffy Jacket",8,3,1,24]
["Stove",5,3,null,0]
["Fishing Pole",5,3,null,0]
[null,null,null,"Total:",{"$f":"SUM(E3:E10)","v":144}]

{"sheet":"Food","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Menu Planner"]
["Food Item","Unit Price","Calories","Quantity","Price","Total Calories"]
["Mt. House Chicken Teriyaki",9,550,1,{"$f":"D3*B3","v":9},{"$f":"D3*C3","v":550}]
["Mt. House Beef Stew",7.5,420,null,{"$f":"D4*B4","v":0},{"$f":"D4*C4","v":0}]
["Mt. House Sweet/Sour Pork",9,600,2,18,1200]
["Taters and Hamburger",4,800,2,8,1600]
["Trout with Lemon (Catch)",0.1,450,null,0,0]
["Chicken Wraps Lunch",4,500,2,8,1000]
["Peanut Butter Ritz Lunch",3,700,3,9,2100]
["Instant Oatmeal (2)",0.75,260,null,0,0]
["Granola w/assorted fruits",2.5,550,3,7.5,1650]
["Eggs and Fried Spam",2.5,540,2,5,1080]
["Snickers (FunSize)",0.25,80,10,2.5,800]
["Cliff Bar",1.5,240,4,6,960]
["Trail Mix",1,200,3,3,600]
["Peach Rings",1,130,2,2,260]
["Almonds",2,530,6,12,3180]
["Fruit Snacks",0.75,130,4,3,520]
["Gatorade",0.5,60,10,5,600]
["Used Calories",11169.62652633829,null,"Totals",{"$f":"SUM(E3:E19)","v":98},{"$f":"SUM(F3:F19)","v":16100}]

{"sheet":"Checkout","index":4,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Checkout"]
[]
["Food Total:",{"$f":"Food!E20","v":98}]
["Rental Total:",{"$f":"Rentals!E11","v":144}]
["SubTotal:",{"$f":"SUM(B3:B4)","v":242}]
[]
[]
["Payment Method:"]
["Name:","John Doe"]
["Card Number:","1234567891234567"]
["VPN:","123"]
["Billing Address:","1924 Mulberry Ln."]
["City:","Bakersville"]
["State:","UT"]
["Zip Code:","84602"]
["Email:","cosmo@byu.edu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Credit"]
["Debit"]

{"sheet":"Help","index":5,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Help Page"]
["Page 1: Planner"]
[]
[]
["Page 2: Rentals"]
[]
[]
["Page 3: Food"]
[]
[]
["Page 4: Checkout"]